package me.helllp.bootman.back.mapper;

import java.util.Set;

import org.apache.ibatis.annotations.Select;

import me.helllp.bootman.back.config.BootmanMapper;
import me.helllp.bootman.back.model.SusrRolePermiss;

public interface SusrRolePermissMapper extends BootmanMapper<SusrRolePermiss> {
	@Select("SELECT DISTINCT N.PERMISSION_NAME FROM susr_user_role R, susr_role_permiss P, susr_permiss N WHERE R.USER_ID = #{userId} AND R.ROLE_ID = P.ROLE_ID AND P.PERMISS_ID = N.ID ")
	public Set<String> selectPermissNameByUserId(Long userId);	
}